Monday July 13, 2009
The Max
function, one of Excel’s statistical functions, is a very useful function that has many applications. What the MAX function does is find the largest
value in a given list of data.
Example uses for the MAX function:
- to find the highest temperature or the highest rainfall in climatic data
- to find the slowest result in a collection of experimental results measured over a set period of time
- to find the longest distance or the highest score from the results of an athletic event
To find out the details on how to use the MAX function, including an example, read the article on the
Excel MAX Function.
Related Articles
Saturday July 11, 2009
It gets a bit frustrating, when working with large
spreadsheets, if every time you go to read the data in a specific
cell the headings at the top of the page or down the side of the sheet disappear. You are left wondering if you are looking at the right
data.
If you’re like me, you want to make certain that you are looking in the right spot, so you
scroll back and forth trying to read first the heading and then the data, heading then the data, until you’re almost sure you have it right.
To avoid this back and forth waste of time, use Excel's “freeze panes” feature. Freeze panes allows you to lock specific
rows and
columns so that they will always be visible on screen no matter how far you scroll to the right or down. It's easy to do and this short article on
Excel 2007 Freeze Panes will have you locking down rows and columns in no time.
Related Articles
Wednesday July 8, 2009
Creating a Drop Down List in Excel 2007
© Ted French
Since entering
data into a
spreadsheet is probably the most commonly performed operation in Excel, Microsoft has included a number of tools and features that make it easier to carry out this task.
One of these, and one that can save you some time if you have to enter the same data repeatedly, is the drop down list.
A drop down list gives you a set number of entries to choose from when entering data. Not only can this speed up data entry, but it can also prevent people from misspelling entries or even from entering the wrong data altogether.
To find out how easy it is to use this feature, read the article on
Creating a Drop Down List in Excel 2007.
Related Articles
Monday July 6, 2009
Sometimes when
data is imported or copied into an Excel
spreadsheet numbers get converted to
labels.
This means that they cannot be used in
formulas or
functions.
To change them back into
values, so that they can be used in calculations, use the VALUE function.
To find out the details of using this function, read the article on the
Excel 2007 VALUE Function.
Related Articles
